unit UnitRelCartaComissaoGuias;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, RLFilters, RLRichFilter, DB, ADODB, RLReport, RLRichText;

type
  TRelCartaComissaoGuias = class(TForm)
    rlRelatorio: TRLReport;
    RLGroup1: TRLGroup;
    RLSubDetail2: TRLSubDetail;
    RLBand2: TRLBand;
    RLDraw40: TRLDraw;
    RLDraw42: TRLDraw;
    RLDraw43: TRLDraw;
    RLDBText8: TRLDBText;
    RLDBText25: TRLDBText;
    RLDBText26: TRLDBText;
    RLDBText27: TRLDBText;
    RLDraw54: TRLDraw;
    RLDraw1: TRLDraw;
    RLBand3: TRLBand;
    RLDraw61: TRLDraw;
    RLDraw63: TRLDraw;
    RLDraw64: TRLDraw;
    RLLabel21: TRLLabel;
    RLDBResult15: TRLDBResult;
    RLDBResult16: TRLDBResult;
    RLDBResult18: TRLDBResult;
    RLDraw68: TRLDraw;
    RLDBResult22: TRLDBResult;
    resSubtotal: TRLDBResult;
    RLLabel24: TRLLabel;
    RLDraw69: TRLDraw;
    RLDraw70: TRLDraw;
    RLDBText36: TRLDBText;
    RLDraw20: TRLDraw;
    RLDraw23: TRLDraw;
    RLDBText32: TRLDBText;
    RLDBText34: TRLDBText;
    RLDBText23: TRLDBText;
    RLDBText24: TRLDBText;
    RLDraw62: TRLDraw;
    RLSubDetail1: TRLSubDetail;
    RLBand4: TRLBand;
    RLDraw74: TRLDraw;
    RLDBText30: TRLDBText;
    rldAjuste: TRLDBText;
    RLDraw10: TRLDraw;
    RLDraw4: TRLDraw;
    RLDraw3: TRLDraw;
    RLDraw13: TRLDraw;
    rlband: TRLBand;
    RLDraw71: TRLDraw;
    rlTexto: TRLRichText;
    RLDraw11: TRLDraw;
    rlTotLiq: TRLLabel;
    rlObs: TRLRichText;
    RLDraw5: TRLDraw;
    RLDraw12: TRLDraw;
    resGuias: TRLDBResult;
    resAjustes: TRLLabel;
    RLBand1: TRLBand;
    RLLabel10: TRLLabel;
    RLDBText1: TRLDBText;
    RLDBText2: TRLDBText;
    RLDBText3: TRLDBText;
    rlLinha: TRLLabel;
    RLDraw2: TRLDraw;
    RLDraw82: TRLDraw;
    RLMemo1: TRLMemo;
    RLLabel9: TRLLabel;
    RLLabel23: TRLLabel;
    RLDBText4: TRLDBText;
    RLDraw6: TRLDraw;
    RLDraw7: TRLDraw;
    RLDraw8: TRLDraw;
    RLDraw9: TRLDraw;
    resGarantia: TRLDBResult;
    resNDepositar: TRLDBResult;
    qryConsulta: TADOQuery;
    qryConsultaBANCO: TStringField;
    qryConsultaGRUPO_CODIGO: TIntegerField;
    qryConsultaCOMISSAO_PERIODO: TStringField;
    qryConsultaGRUPO_CREDIGI: TBCDField;
    qryConsultaCALGUIA_CODIGO: TIntegerField;
    qryConsultaCOMISSAO_JUNTAR: TStringField;
    qryConsultaCOMISSAO_BANCO: TSmallintField;
    qryConsultaCOMISSAO_AGENCIA: TStringField;
    qryConsultaCOMISSAO_CONTA: TStringField;
    qryConsultaCOMISSAO_TITULAR: TStringField;
    qryConsultaCOMISSAO_GARANTIA: TBCDField;
    qryConsultaCOMISSAO_ISS: TBCDField;
    qryConsultaCOMISSAO_OBS: TMemoField;
    qryConsultaGRUPO_ATT: TStringField;
    qryConsultaGRUPO_DESCRICAO: TStringField;
    qryConsultaGRUPO_TIPOCONTA: TStringField;
    qryConsultaGRUPO_OI: TBCDField;
    qryConsultaGRUPO_TIM: TBCDField;
    qryConsultaCOMISSAO_AJUSTES: TBCDField;
    qryConsultaCARTA_DATAINI: TDateTimeField;
    qryConsultaCARTA_DATAFIM: TDateTimeField;
    qryConsultaCARTA_GERACAO: TDateTimeField;
    qryConsultaCARTA_CREDITO: TDateTimeField;
    qryConsultaCARTA_OBS: TMemoField;
    qryConsultaCARTA_AVISO: TMemoField;
    qryConsultaImpressao: TStringField;
    qryConsultaCOMISSAO_NDEPOSITAR: TStringField;
    qryConsultaGRUPO_EMBRATELLDR: TBCDField;
    qryConsultaGRUPO_EMBRATELLIVRE: TBCDField;
    qryConsultaCOMISSAO_OIRECARGA: TBCDField;
    dsConsulta: TDataSource;
    dsPostos: TDataSource;
    qryPostos: TADOQuery;
    StringField3: TStringField;
    qryPostosVALGUIAS: TBCDField;
    qryPostosGRUPO_CODIGO: TIntegerField;
    qryPostosCOMISSAO_PERIODO: TStringField;
    qryPostosFRANQUIA_CODIGO: TIntegerField;
    qryPostosGUIAS: TIntegerField;
    qryPostosMEDIA: TBCDField;
    qryPostosCARTA_DATAINI: TDateTimeField;
    qryPostosCARTA_DATAFIM: TDateTimeField;
    qryPostosCARTA_GERACAO: TDateTimeField;
    qryPostosCARTA_CREDITO: TDateTimeField;
    qryPostosCARTA_OBS: TMemoField;
    qryPostosCOMISSAO_NDEPOSITAR: TStringField;
    qryPostosCOMISSAO_AJUSTES: TBCDField;
    qryPostosCOMISSAO_GARANTIA: TBCDField;
    qryPostosCOMISSAO_ISS: TBCDField;
    qryPostosCARTA_PAGO: TBooleanField;
    qryPostosFRANQUIA: TStringField;
    dsAjustes: TDataSource;
    qryAjustes: TADOQuery;
    qryAjustesGRUPO_CODIGO: TIntegerField;
    qryAjustesCOMISSAO_PERIODO: TStringField;
    qryAjustesAJUSTEGRUPO_DESCRICAO: TStringField;
    qryAjustesAJUSTECOMISSAO_VALOR: TBCDField;
    z: TRLRichFilter;
    ADOQuery1: TADOQuery;
    StringField1: TStringField;
    IntegerField1: TIntegerField;
    StringField2: TStringField;
    BCDField1: TBCDField;
    IntegerField2: TIntegerField;
    StringField4: TStringField;
    SmallintField1: TSmallintField;
    StringField5: TStringField;
    StringField6: TStringField;
    StringField7: TStringField;
    BCDField2: TBCDField;
    BCDField3: TBCDField;
    MemoField1: TMemoField;
    StringField8: TStringField;
    StringField9: TStringField;
    StringField10: TStringField;
    BCDField4: TBCDField;
    BCDField5: TBCDField;
    BCDField6: TBCDField;
    DateTimeField1: TDateTimeField;
    DateTimeField2: TDateTimeField;
    DateTimeField3: TDateTimeField;
    DateTimeField4: TDateTimeField;
    MemoField2: TMemoField;
    MemoField3: TMemoField;
    StringField11: TStringField;
    StringField12: TStringField;
    BCDField7: TBCDField;
    BCDField8: TBCDField;
    BCDField9: TBCDField;
    DataSource1: TDataSource;
    DataSource2: TDataSource;
    ADOQuery2: TADOQuery;
    StringField13: TStringField;
    BCDField10: TBCDField;
    IntegerField3: TIntegerField;
    StringField14: TStringField;
    IntegerField4: TIntegerField;
    IntegerField5: TIntegerField;
    BCDField11: TBCDField;
    DateTimeField5: TDateTimeField;
    DateTimeField6: TDateTimeField;
    DateTimeField7: TDateTimeField;
    DateTimeField8: TDateTimeField;
    MemoField4: TMemoField;
    StringField15: TStringField;
    BCDField12: TBCDField;
    BCDField13: TBCDField;
    BCDField14: TBCDField;
    BooleanField1: TBooleanField;
    StringField16: TStringField;
    DataSource3: TDataSource;
    ADOQuery3: TADOQuery;
    IntegerField6: TIntegerField;
    StringField17: TStringField;
    StringField18: TStringField;
    BCDField15: TBCDField;
    RLRichFilter1: TRLRichFilter;
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  RelCartaComissaoGuias: TRelCartaComissaoGuias;

implementation

{$R *.dfm}

end.
